BEGIN TRANSACTION
GO
ALTER TABLE dbo.Invoice_TransDetail ADD
	StatusID smallint NULL
GO
COMMIT

------------------------------------------------------------------

BEGIN TRANSACTION
GO
	DELETE FROM GROUPS WHERE Type=8
GO
COMMIT

------------------------------------------------------------------

/****** Object:  Table [dbo].[Invoice_SSPitem]    Script Date: 08/27/2020 17:07:10 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Invoice_SSPitem]') AND type in (N'U'))
DROP TABLE [dbo].[Invoice_SSPitem]

------------------------------------------------------------------

/****** Object:  Table [dbo].[Invoice_SSPitem]    Script Date: 08/27/2020 17:07:16 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Invoice_SSPitem](
	[inv_SSPItemID] [bigint] IDENTITY(1,1) NOT NULL,
	[inv_SSPID] [bigint] NOT NULL,
	[SubTypeID] [smallint] NULL,
	[DTypeID] [smallint] NULL,
	[QTY] [numeric](15, 4) NOT NULL CONSTRAINT [DF_Invoice_SSPitem_QTY]  DEFAULT ((0)),
	[Amount] [numeric](15, 4) NOT NULL CONSTRAINT [DF_Invoice_SSPitem_Amount]  DEFAULT ((0)),
	[ExRate] [numeric](15, 4) NOT NULL CONSTRAINT [DF_Invoice_SSPitem_ExRate]  DEFAULT ((0)),
	[NetAmount] [numeric](15, 4) NOT NULL CONSTRAINT [DF_Invoice_SSPitem_NetAmount]  DEFAULT ((0)),
	[Type] [tinyint] NOT NULL CONSTRAINT [DF_Invoice_SSPitem_Type]  DEFAULT ((0))	
 CONSTRAINT [PK_Invoice_SSPitem] PRIMARY KEY CLUSTERED 
(
	[inv_SSPItemID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF